﻿CREATE TABLE [dbo].[CiParameter] (
    [Id]               INT            IDENTITY (1, 1) NOT NULL,
    [CategoryId]       NVARCHAR (50)  NOT NULL,
    [ParameterId]      NVARCHAR (50)  NOT NULL,
    [ParameterCode]    NVARCHAR (50)  NOT NULL,
    [ParameterContent] NVARCHAR (800) NULL,
    [Worked]           INT            CONSTRAINT [DF__CiParamet__Worke__29572725] DEFAULT ((0)) NOT NULL,
    [Enabled]          INT            CONSTRAINT [DF__CiParamet__Enabl__2A4B4B5E] DEFAULT ((1)) NOT NULL,
    [Description]      NVARCHAR (800) NULL,
    [SortCode]         INT            NULL,
    [DeleteMark]       INT            CONSTRAINT [DF_CiParameter_DeleteMark] DEFAULT ((0)) NULL,
    [CreateOn]         DATETIME       CONSTRAINT [DF__CiParamet__Creat__2B3F6F97] DEFAULT (getdate()) NOT NULL,
    [CreateUserId]     NVARCHAR (50)  NULL,
    [CreateBy]         NVARCHAR (50)  NULL,
    [ModifiedOn]       DATETIME       NULL,
    [ModifyUserId]     NVARCHAR (50)  NULL,
    [ModifiedBy]       NVARCHAR (50)  NULL,
    CONSTRAINT [PK_CIPARAMETER] PRIMARY KEY NONCLUSTERED ([Id] ASC)
);

